<?php
		require(dirname(dirname(dirname(dirname(dirname(__FILE__)))))."/app/include/dbbackup/inc/header.php");
	ExcuteSQL("DROP TABLE IF EXISTS `phpyun_news_group`;");
CreateTable("CREATE TABLE `phpyun_news_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `keyid` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `sort` int(11) DEFAULT '0',
  `rec` int(1) DEFAULT '0',
  `is_menu` int(1) DEFAULT '0',
  `rec_news` int(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=42 DEFAULT CHARSET=utf8");
ExcuteSQL("insert into `phpyun_news_group` values('1','0','职业指导','1','1','0','1');");
ExcuteSQL("insert into `phpyun_news_group` values('2','0','案例解析','0','0','0','1');");
ExcuteSQL("insert into `phpyun_news_group` values('3','0','管理百科','10','1','0','1');");
ExcuteSQL("insert into `phpyun_news_group` values('4','0','高端访谈','0','0','0','1');");
ExcuteSQL("insert into `phpyun_news_group` values('5','0','劳动法规','5','1','0','1');");
ExcuteSQL("insert into `phpyun_news_group` values('6','0','简历指导','2','1','0','1');");
ExcuteSQL("insert into `phpyun_news_group` values('7','0','现场招聘会','1','1','0','1');");
ExcuteSQL("insert into `phpyun_news_group` values('8','0','求职新闻','3','0','0','0');");
ExcuteSQL("insert into `phpyun_news_group` values('9','0','面试秘籍','4','0','0','1');");
ExcuteSQL("insert into `phpyun_news_group` values('10','0','薪酬行情','2','0','0','0');");
ExcuteSQL("insert into `phpyun_news_group` values('17','0','娱乐节目','0','0','0','0');");
ExcuteSQL("insert into `phpyun_news_group` values('36','0','心理治愈','0','1','0','1');");
ExcuteSQL("insert into `phpyun_news_group` values('33','0','焦点访谈','0','0','0','0');");
ExcuteSQL("insert into `phpyun_news_group` values('37','0','简历模板','0','0','0','0');");
ExcuteSQL("insert into `phpyun_news_group` values('38','0','心理康复','0','0','0','0');");
ExcuteSQL("insert into `phpyun_news_group` values('40','0','最新薪酬','0','0','0','0');");
ExcuteSQL("insert into `phpyun_news_group` values('41','0','简历表格','0','0','0','0');");

		require(dirname(dirname(dirname(dirname(dirname(__FILE__)))))."/app/include/dbbackup/inc/footer.php");
	?>